This is a discussion on FIRST day of month formula!!!!! within the Excel Questions forums, part of the Question Forums category; Hi, in cell B13 I have a date, 04-Jan-2010 I cel A2 I have a formula that looks @ cell ...
Hi, in cell B13 I have a date, 04-Jan-2010
I cel A2 I have a formula that looks @ cell A1 and adds 1 month while taking into account weekends and some pre defined busines days.
In this case it would yield 04-Jan-2010.
I need to alter this formula in a way that it takes the first day of the month in cell B13 instead of the actuall mentioned date (04-jan-2010).
Thank you for your help
Given a date value in cell B13, the first day of this month can be calculated using: