How to get a cell to display the date of the first day of the month

bugmenot · 07-22-2009, 12:44 PM

I basically want a cell that displays the date of the first day of the month as a date cell.

So today it would be 7/1/2009

Thanks for the help

Edit:
After a search i found out this probably won't work because what I am trying to do is get the number of work days Month-to-Date. I was going to use networkdays but apparently it won't take a date field? Any help would be much appreciated

**somesoldiers** · 07-22-2009, 01:56 PM

if you have a list of dates and want to find the first day of a particular month eg date in cell A1 is 25-Feb-2008 use =DATE(YEAR(A1),MONTH(A1),1) in cell B1 (this will give you the first day of a particular month) and to get the number of workdays between A and B use =ABS(NETWORKDAYS(A1,B1)) in cell C1.

will look something like the below

13-Feb-09 01-Feb-09 10