How to Resolve - add months, but only reflect the first date?

add months, but only reflect the first date

This adds three months.
=DATE(YEAR(C2),MONTH(C2)+3,MIN(DAY(C2),DAY(DATE(YEAR(C2),MONTH(C2)+3+1,0))))
 
But i only want to display the first date of the month.

Example:
If date is C2 is today 06/14/2012.
Result would be 09/01/2012.

So, any date in this month would return 09/01/2012.

Solutions to the Problem add months, but only reflect the first date

Download SmartPCFixer for Free Now

Try this:
 
=DATE(YEAR(C2),MONTH(C2)+3,1)
 
Hope this helps.
 
Pete

Because of this add months, but only reflect the first date error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error add months, but only reflect the first date can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve add months, but only reflect the first date error or repair the corrupted and damaged Windows files, you will need a add months, but only reflect the first date error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

1. Start the computer and log in as administrator
2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
4. On the new confirmation window that appears, click Next
5. Restart your computer after the restoration has been completed

Recommended Method to Repair the Problem: add months, but only reflect the first date:

How to Fix add months, but only reflect the first date with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.

Related: [Solved] Applications have stopped working with SP1 on Windows 7!,[Solved] I can't find auto complete text in word 2007,[Solution] I need to keep reinstalling eHome Infrared Transceiver driver everytime my computer shuts down.,How to Resolve - system restore not working windows 7?,Unable to open embedded word file on the intranet. [Solved],Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:Acer Aspire 5738 laptop running Windows 7 shows 35% available (plugged in, not charging) Error,Tech Support: Acer laptop keyboard,Fast Solution to Problem: Acer 5532 Factory Default Disk: System Restore Failure!\/Harddrive issues!,Solution to Problem: a internet explore 9 nao esta respondendo,About installing a lexmark printer with windows 7 [Solved],Cannot delete empty file icon on desktop...,Cannot download flashplayer,can't get the CIA review progrom install which is an older version,Cannot access one website-DNS server not responding.,Can't Receive or Send Vista Windows Mail - Router stopped recognizing DSL connection & wants to dial up