Hi I have a month in text form in A1 (January) and a Year (2013) in B1, i need C1 to return the first date of that month and D1 to return the Last date of that month based on the Month and year typed in A1 and B1.
Cheers
JD
Hi I have a month in text form in A1 (January) and a Year (2013) in B1, i need C1 to return the first date of that month and D1 to return the Last date of that month based on the Month and year typed in A1 and B1.
Cheers
JD
C1= (a1&b1)*1 OR eomonth(a1&b1,-1)+1
d1=eomonth(a1&b1,0)
Last edited by daffodil11; 11-05-2013 at 12:01 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks