formula problem
Posted by Nick Scurr on December 30, 2001 8:24 AM
I need to know how to convert the day in a date into a number. the number is ina seperate sheet. there are seven numbers, each one corresponds to a day. so i need to take the date, turn the day into a number and then use that number to find the day, i've been racking my brains out, sigh
Posted by John on December 30, 2001 9:09 AM
The Weekday() function will return the day of the week (a number 1-7 ). The Day() function will return the day of the month (a number 1-31).
Posted by Aladin Akyurek on December 30, 2001 9:27 AM
In case you're looking for the name of the day given a date, use:
=TEXT(A1,"dddd")
Aladin
===========
